package com.zy.web.domain;

import com.zy.common.core.domain.BaseEntity;
import lombok.Data;
import org.hibernate.annotations.Comment;
import org.hibernate.annotations.SQLDelete;
import org.hibernate.annotations.Where;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
import java.time.LocalDateTime;

@Data
@Entity
@Table(name = "zy_result")
@org.hibernate.annotations.Table(appliesTo = "zy_result", comment = "结果表")
@Where(clause = "deleted is null or deleted != true")
@SQLDelete(sql = "update zy_result set deleted = true where id = ? ")
public class ZyResult extends BaseEntity {
    /**
     * 项目名称
     */
    @Comment("项目名称")
    @Column(name = "project_name")
    private String projectName;

    /**
     * 项目类型
     */
    @Comment("项目类型")
    @Column(name = "project_type")
    private String projectType;

    /**
     * 第一名名称
     */
    @Comment("第一名名称")
    @Column(name = "first_place_name")
    private String firstPlaceName;

    /**
     * 第一名时间
     */
    @Comment("第一名时间")
    @Column(name = "first_place_time")
    private Double firstPlaceTime;

    /**
     * 第二名名称
     */
    @Comment("第二名名称")
    @Column(name = "second_place_name")
    private String secondPlaceName;

    /**
     * 第二名时间
     */
    @Comment("第二名时间")
    @Column(name = "second_place_time")
    private Double secondPlaceTime;

    /**
     * 第三名名称
     */
    @Comment("第三名名称")
    @Column(name = "third_place_name")
    private String thirdPlaceName;

    /**
     * 第三名时间
     */
    @Comment("第三名时间")
    @Column(name = "third_place_time")
    private Double thirdPlaceTime;

    /**
     * 第四名名称
     */
    @Comment("第四名名称")
    @Column(name = "fourth_place_name")
    private String fourthPlaceName;

    /**
     * 第四名时间
     */
    @Comment("第四名时间")
    @Column(name = "fourth_place_time")
    private Double fourthPlaceTime;

}
